sp_helpfile
go
use RD_PurchaseMart
ALTER DATABASE RD_PurchaseMart 
SET offline 
GO
ALTER DATABASE RD_PurchaseMart 
MODIFY FILE ( NAME = RD_PurchaseMart, FILENAME = 'K:\Database Files\RD_PurchaseMart.mdf'
) 
ALTER DATABASE RD_PurchaseMart 
MODIFY FILE ( NAME = RD_PurchaseMart_2, FILENAME = 'K:\Database Files\RD_PurchaseMart_2.ndf'
)

ALTER DATABASE RD_PurchaseMart 
MODIFY FILE ( NAME = RD_PurchaseMart_3, FILENAME = 'K:\Database Files\RD_PurchaseMart_3.ndf'
) 

ALTER DATABASE RD_PurchaseMart 
MODIFY FILE ( NAME = RD_PurchaseMart_4, FILENAME = 'K:\Database Files\RD_PurchaseMart_4.ndf'
) 

ALTER DATABASE RD_PurchaseMart 
SET online 
GO
sp_helpfile
go
